﻿using System;
using System.Text;
using System.Collections.Generic;
using System.Data;
namespace OneMake.Model
{
    [PetaPoco.TableName("hdp_d_deal")]
    [PetaPoco.PrimaryKey("oid")]
    public class hdp_d_deal
    {
        [MapToField(FieldName = "统计日期")]
        public DateTime stat_datetime { get; set; }

        [MapToExcel(ColumnName = "买家昵称")]
        public string buyer_nick { get; set; }
        [MapToExcel(ColumnName = "交易标题")]
        public string deal_title { get; set; }
        [MapToExcel(ColumnName = "交易类型")]
        public string deal_type { get; set; }
        [MapToExcel(ColumnName = "交易创建时间")]
        public string deal_createtime { get; set; }
        [MapToExcel(ColumnName = "交易编号")]
        public string deal_sn { get; set; }
        [MapToExcel(ColumnName = "卖家是否已评价")]
        public string seller_commeted { get; set; }
        [MapToExcel(ColumnName = "买家是否已评价")]
        public string buyer_commeted { get; set; }
        [MapToExcel(ColumnName = "交易状态")]
        public string deal_status { get; set; }
        [MapToExcel(ColumnName = "实付金额")]
        public double actual_paid { get; set; }
        [MapToExcel(ColumnName = "系统优惠金额")]
        public double sys_discount { get; set; }
        [MapToExcel(ColumnName = "卖家手工调整金额")]
        public double seller_discount { get; set; }
        [MapToExcel(ColumnName = "邮费")]
        public double shipment { get; set; }
        [MapToExcel(ColumnName = "商品金额")]
        public double prd_amount { get; set; }
        [MapToExcel(ColumnName = "付款时间")]
        public string paid_time { get; set; }
        [MapToExcel(ColumnName = "交易结束时间")]
        public string deal_endtime { get; set; }
        [MapToExcel(ColumnName = "交易修改时间")]
        public string deal_changetime { get; set; }
        [MapToExcel(ColumnName = "卖家发货时间")]
        public string seller_sendtime { get; set; }
        [MapToExcel(ColumnName = "买家获得积分")]
        public double buyer_getcredit { get; set; }
        [MapToExcel(ColumnName = "买家使用积分")]
        public double buyer_usecredit { get; set; }
        [MapToExcel(ColumnName = "买家实际使用积分")]
        public double buyer_actual_usecredit { get; set; }
        [MapToExcel(ColumnName = "卖家实际收到的支付宝打款金额")]
        public double seller_actualrecv { get; set; }
        [MapToExcel(ColumnName = "交易佣金")]
        public double deal_commission { get; set; }
        [MapToExcel(ColumnName = "商品图片绝对途径")]
        public string prd_image { get; set; }
        [MapToExcel(ColumnName = "商品数字编号")]
        public string prd_flowno { get; set; }
        [MapToExcel(ColumnName = "商品购买数量")]
        public int prd_count { get; set; }
        [MapToExcel(ColumnName = "商品价格")]
        public double prd_price { get; set; }
        [MapToExcel(ColumnName = "货到付款服务费")]
        public double n_cod { get; set; }
        [MapToExcel(ColumnName = "创建交易时的物流方式")]
        public string shipment_oncreate { get; set; }
        [MapToExcel(ColumnName = "收货人的姓名")]
        public string recv_name { get; set; }
        [MapToExcel(ColumnName = "收货人的所在省份")]
        public string recv_province { get; set; }
        [MapToExcel(ColumnName = "收货人的所在城市")]
        public string recv_city { get; set; }
        [MapToExcel(ColumnName = "收货人的所在地区")]
        public string recv_area { get; set; }
        [MapToExcel(ColumnName = "收货人的详细地址")]
        public string recv_address { get; set; }
        [MapToExcel(ColumnName = "收货人的邮编")]
        public string recv_post { get; set; }
        [MapToExcel(ColumnName = "收货人的手机号码")]
        public string recv_mobile { get; set; }
        [MapToExcel(ColumnName = "收货人的电话号码")]
        public string recv_telno { get; set; }
        [MapToExcel(ColumnName = "(子订单)商品标题")]
        public string sub_prd_title { get; set; }
        [MapToExcel(ColumnName = "(子订单)商品图片的绝对路径")]
        public string sub_prd_image { get; set; }
        [MapToExcel(ColumnName = "(子订单)商品价格")]
        public double sub_prd_price { get; set; }
        [MapToExcel(ColumnName = "(子订单)购买数量")]
        public int sub_n_buycount { get; set; }
        [MapToExcel(ColumnName = "(子订单)商品数字ID")]
        public string sub_prd_flowno { get; set; }
        [MapToExcel(ColumnName = "(子订单)商品的最小库存单位SKU的ID")]
        public string sub_prd_minstore { get; set; }
        [MapToExcel(ColumnName = "(子订单)退款状态")]
        public string sub_return_status { get; set; }
        [MapToExcel(ColumnName = "(子订单)订单状态")]
        public string sub_status { get; set; }
        [MapToExcel(ColumnName = "(子订单)子订单编号")]
        public string sub_id { get; set; }
        [MapToExcel(ColumnName = "(子订单)应付金额")]
        public double sub_need_amount { get; set; }
        [MapToExcel(ColumnName = "(子订单)实付金额")]
        public double sub_actual_amount { get; set; }
        [MapToExcel(ColumnName = "(子订单)优惠金额")]
        public double sub_discount_amount { get; set; }
        [MapToExcel(ColumnName = "(子订单)手工调整金额")]
        public double sub_adjust_amount { get; set; }
        [MapToExcel(ColumnName = "(子订单)SKU的值")]
        public string sub_sku_value { get; set; }
        [MapToExcel(ColumnName = "(子订单)套餐的值")]
        public string sub_pkg_value { get; set; }
        [MapToExcel(ColumnName = "(子订单)买家是否已评价")]
        public string sub_buyer_commeted { get; set; }
        [MapToExcel(ColumnName = "(子订单)卖家是否已评价")]
        public string sub_seller_commeted { get; set; }
        [MapToExcel(ColumnName = "(子订单)商家外部编码")]
        public string sub_ext_flowno { get; set; }
        [MapToExcel(ColumnName = "(子订单)外部网店自己定义的SKU编号")]
        public string sub_ext_shop_sku { get; set; }
        [MapToExcel(ColumnName = "(子订单)退款ID")]
        public string sub_return_id { get; set; }
        [MapToExcel(ColumnName = "(子订单)卖家类型")]
        public string sub_seller_type { get; set; }

        
		/////////////////////////////////////////
        [MapToField(FieldName = "门店编号")]
        public int shopid { get; set; }
        [MapToField(FieldName = "文件编号")]
        public int fileid { get; set; }
        [MapToField(FieldName = "编号")]
        public int oid { get; private set; }    
    }
}